if exists (select 1
            from  sysobjects
           where  id = object_id('bd_sys_itemClass')
            and   type = 'U')
   drop table bd_sys_itemClass
go

/*==============================================================*/
/* Table: bd_sys_itemClass                                      */
/*==============================================================*/
create table bd_sys_itemClass (
   classId              int                  not null,
   number               VARCHAR(20)          not null,
   name                 VARCHAR(255)         not null,
   tableName            VARCHAR(30)          null,
   dataStatus           int                  not null default 0,
   constraint PK_BD_SYS_ITEMCLASS primary key (classId)
)
go

